[dbo].[UserDefinedMultiInstanceProperty]

Property	Value
Created	5:29:22 PM Wednesday, July 27, 2011
Last Modified	11:40:10 AM Monday, February 20, 2012

Property

Value

Created

5:29:22 PM Wednesday, July 27, 2011

Last Modified

11:40:10 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$	TableName	[sys].[sysname]	256
$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$	PropertyName	[sys].[sysname]	256
$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$	RowID	nvarchar(16)	32
$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$	RowKey	uniqueidentifier	16
$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$	RowSequence	int	4
	PropertyIntValue	int	4
	PropertyDateTimeValue	datetime	8
	PropertyGuidValue	uniqueidentifier	16
	PropertyDecimalValue	decimal(38,12)	17
	PropertyBooleanValue	bit	1
	PropertyStringValue	nvarchar(400)	800

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$

TableName

[sys].[sysname]

256

$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$

PropertyName

[sys].[sysname]

256

$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$

RowID

nvarchar(16)

$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$

RowKey

uniqueidentifier

$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$

RowSequence

int

PropertyIntValue

int

PropertyDateTimeValue

datetime

PropertyGuidValue

uniqueidentifier

PropertyDecimalValue

decimal(38,12)

PropertyBooleanValue

bit

PropertyStringValue

nvarchar(400)

800

	Name	Columns
$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$	PK_UserDefinedMultiInstanceProperty	TableName, PropertyName, RowID, RowKey, RowSequence
	IX_UserDefinedMultiInstanceProperty_BooleanValue	PropertyBooleanValue
	IX_UserDefinedMultiInstanceProperty_DateTimeValue	PropertyDateTimeValue
	IX_UserDefinedMultiInstanceProperty_DecimalValue	PropertyDecimalValue
	IX_UserDefinedMultiInstanceProperty_GuidValue	PropertyGuidValue
	IX_UserDefinedMultiInstanceProperty_IntValue	PropertyIntValue
	IX_UserDefinedMultiInstanceProperty_StringValue	PropertyStringValue

Name

Columns

Unique

$Cluster Primary Key PK_UserDefinedMultiInstanceProperty: TableName\PropertyName\RowID\RowKey\RowSequence$

PK_UserDefinedMultiInstanceProperty

TableName, PropertyName, RowID, RowKey, RowSequence

IX_UserDefinedMultiInstanceProperty_BooleanValue

PropertyBooleanValue

IX_UserDefinedMultiInstanceProperty_DateTimeValue

PropertyDateTimeValue

IX_UserDefinedMultiInstanceProperty_DecimalValue

PropertyDecimalValue

IX_UserDefinedMultiInstanceProperty_GuidValue

PropertyGuidValue

IX_UserDefinedMultiInstanceProperty_IntValue

PropertyIntValue

IX_UserDefinedMultiInstanceProperty_StringValue

PropertyStringValue

SQL Script

CREATE TABLE [dbo].[UserDefinedMultiInstanceProperty]
(
[TableName] [sys].[sysname] NOT NULL,
[PropertyName] [sys].[sysname] NOT NULL,
[RowID] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[RowKey] [uniqueidentifier] NOT NULL,
[RowSequence] [int] NOT NULL,
[PropertyIntValue] [int] NULL,
[PropertyDateTimeValue] [datetime] NULL,
[PropertyGuidValue] [uniqueidentifier] NULL,
[PropertyDecimalValue] [decimal] (38, 12) NULL,
[PropertyBooleanValue] [bit] NULL,
[PropertyStringValue] [nvarchar] (400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UserDefinedMultiInstanceProperty] ADD CONSTRAINT [PK_UserDefinedMultiInstanceProperty] PRIMARY KEY CLUSTERED ([TableName], [PropertyName], [RowID], [RowKey], [RowSequence]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedMultiInstanceProperty_BooleanValue] ON [dbo].[UserDefinedMultiInstanceProperty] ([PropertyBooleanValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedMultiInstanceProperty_DateTimeValue] ON [dbo].[UserDefinedMultiInstanceProperty] ([PropertyDateTimeValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedMultiInstanceProperty_DecimalValue] ON [dbo].[UserDefinedMultiInstanceProperty] ([PropertyDecimalValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedMultiInstanceProperty_GuidValue] ON [dbo].[UserDefinedMultiInstanceProperty] ([PropertyGuidValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedMultiInstanceProperty_IntValue] ON [dbo].[UserDefinedMultiInstanceProperty] ([PropertyIntValue]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UserDefinedMultiInstanceProperty_StringValue] ON [dbo].[UserDefinedMultiInstanceProperty] ([PropertyStringValue]) ON [PRIMARY]
GO